UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tiOPOxyPA6For0SLk1naJGmCC5oky+KV6gW+1YMRYsk='
WHERE
key_id = '5d65be5fdfb0716b594ab18e8b1e16c81018c61915d5b9fea56e7cb7c6609bd3'
AND (
token = 'tiOPOxyPA6For0SLk1naJGmCC5oky+KV6gW+1YMRYsk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)