UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TxRSYD8AUo422DumE10ezQuIl2fVBFyqUOeznU5StC0='
WHERE
key_id = '4146535e59ec3ef8ef6322b0f1fec4e94c5d8834aaee8d58d57599e72f3321c9'
AND (
token = 'TxRSYD8AUo422DumE10ezQuIl2fVBFyqUOeznU5StC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)