UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xM114uJmHL5e4qK9Ny55wx/WiDh7WkDaqdAGLukRpuA='
WHERE
key_id = 'a8a1b7683b90464fc9a22f01e8a0a9c049ec69d34a4dd8db2d257da06181604f'
AND (
token = 'xM114uJmHL5e4qK9Ny55wx/WiDh7WkDaqdAGLukRpuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)