UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YB2g9SmLITNctWwxDFcC6PYXurBXci7UnWHTUSw3D3g='
WHERE
key_id = '5ac163818ce805ae50d0aad5f2f48ad3757223132df388d0e28b1c442b9a0151'
AND (
token = 'YB2g9SmLITNctWwxDFcC6PYXurBXci7UnWHTUSw3D3g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)