UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HwSZh08L6f1zg2ivkbiic28rV1qZdxaOpI0BrYFi7bw='
WHERE
key_id = '78cda86b79aaaadb2e17dbbe5126da49803f2fbe15fa543b488e4ec9d9048922'
AND (
token = 'HwSZh08L6f1zg2ivkbiic28rV1qZdxaOpI0BrYFi7bw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)