UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NgOLyHJbKX650c1SEoBLiVE+3+SqBJqDY05ZidZ6G9c='
WHERE
key_id = '12fb244510b2332dc9eef1de1c4d51b808f36473fa153f08d3305ce869481645'
AND (
token = 'NgOLyHJbKX650c1SEoBLiVE+3+SqBJqDY05ZidZ6G9c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)