UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rG5tE8c+ftQ++toML5MiiIC1vdvbmCifAjxKeX1PfAM='
WHERE
key_id = 'bcc14f381413586cdf5e25422e1df3e1e51e2390224a8b359d3b206436213937'
AND (
token = 'rG5tE8c+ftQ++toML5MiiIC1vdvbmCifAjxKeX1PfAM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)