UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vdgLAc4AcvaFQ2lj5BLaSwrzpBvJ5jpk6GYDede/Hn8='
WHERE
key_id = '8f28c774bc8f3218d5ebc0357020a79b80216108a813d24ce639d97e283208dd'
AND (
token = 'vdgLAc4AcvaFQ2lj5BLaSwrzpBvJ5jpk6GYDede/Hn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)