UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tZa77ttK95u2uvwYRGHLdUfwCtmTMkINUi9YZkjrlqI='
WHERE
key_id = 'a45057ba2d5cb5831a372741b0645ffd705fc268be35dc8c9335b4a542d5646b'
AND (
token = 'tZa77ttK95u2uvwYRGHLdUfwCtmTMkINUi9YZkjrlqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)