UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sW9b4olTUlUeTt5QLZWrLb2y7R8tdy7WzPlrMpUR8xk='
WHERE
key_id = 'ff4b6a58dbd3fbdcfd9d80b218642fb34b0a8d494b542d434bbe529ee9e9c822'
AND (
token = 'sW9b4olTUlUeTt5QLZWrLb2y7R8tdy7WzPlrMpUR8xk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)