UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LMjMi4MvZT5OAeKu1IsvBmHcaowuf08FrizfJl5VVvs='
WHERE
key_id = '0eb0ad12ced100433af0b0ddce5ddca1dc722841d61cc22e53d1c91c7db86d8f'
AND (
token = 'LMjMi4MvZT5OAeKu1IsvBmHcaowuf08FrizfJl5VVvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)