UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1cYAW3EwGS94LtNHflmg+iwkGFzLaI2kEBZmyKy4D8s='
WHERE
key_id = '0163ea661403f815eff1560abff0ce140d3e5d58994c4c6246eef1ca53a802a1'
AND (
token = '1cYAW3EwGS94LtNHflmg+iwkGFzLaI2kEBZmyKy4D8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)