UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zGbn8OjBJy7g27X7GOg/MoaTCwUggaOal3HLtjAuTFc='
WHERE
key_id = '10870687658077c1a47f8fae86aeb3d1cc83331d821cc8986f5e8e014dbb049b'
AND (
token = 'zGbn8OjBJy7g27X7GOg/MoaTCwUggaOal3HLtjAuTFc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)