UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'anBGI7bq8MrK5ZnP5cFdh3b4reVQpHgv9hOScxxo4ck='
WHERE
key_id = '564a244053c3a34b773bc75e263547f4ef53ba0e43a38c7384cfac10c55569bd'
AND (
token = 'anBGI7bq8MrK5ZnP5cFdh3b4reVQpHgv9hOScxxo4ck='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)