UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pimvLIN0IJYl5DvOup/jOXFJo/j2+enSPs2/3/Kdago='
WHERE
key_id = '33fec15d242f5054dd8c08722023fcbe45ee2b35d97fe2df727e5a0149648a93'
AND (
token = 'pimvLIN0IJYl5DvOup/jOXFJo/j2+enSPs2/3/Kdago='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)