UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bhErIFutekGz1XY1im+lOiswk3fHprCoi60Zbhbt0rg='
WHERE
key_id = 'b7765ae21b05fca65e35d1811e362a8d831751a25d5a2b065749ef86bd1becc5'
AND (
token = 'bhErIFutekGz1XY1im+lOiswk3fHprCoi60Zbhbt0rg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)