UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uHdVcUgYmbQO4JH5+oXN8HkeNtE+DWwFXK+Mv9Avli0='
WHERE
key_id = '47cea979e48a7fa3642267faa3d8281c003defbefcbeb3689a218546b3d3a19c'
AND (
token = 'uHdVcUgYmbQO4JH5+oXN8HkeNtE+DWwFXK+Mv9Avli0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)