UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DHzWvkGYGW1I0Zz80m5HXSU5kqek946wSuJrdUcU9vI='
WHERE
key_id = '1e5a68f5b56049c155e1e1f410b40ba013fa6fcbd291044acf71294fe04efdba'
AND (
token = 'DHzWvkGYGW1I0Zz80m5HXSU5kqek946wSuJrdUcU9vI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)