UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R8I/qytjjIE439IA10vqr5//K/iKPnzv71VcXEmsuho='
WHERE
key_id = 'de9c05496632514e7e0cc5d610305922a5f61eda7e282b3e6995186aa3170613'
AND (
token = 'R8I/qytjjIE439IA10vqr5//K/iKPnzv71VcXEmsuho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)