UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hI7vmBZW8UsHbWsuB2q1LxziA8eAs9R+CzGWksX3NYg='
WHERE
key_id = 'a2d7bbcd5458e8ff0bc41c028dddf4fc4e151f30d3da3143db1ae33f14ca5235'
AND (
token = 'hI7vmBZW8UsHbWsuB2q1LxziA8eAs9R+CzGWksX3NYg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)