UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zI92KqB62vb6yinnAoottqfH147WOKDqdz53RJxLbsA='
WHERE
key_id = '434f0b84842f7e7b5c44e4775510d10f8a8bcb87b2a9c52b5974db5599dea4f9'
AND (
token = 'zI92KqB62vb6yinnAoottqfH147WOKDqdz53RJxLbsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)