UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qcEC0LZUVHmwcGL4HCPxOp8pfT96E56FRaatHGMpLBc='
WHERE
key_id = 'bd3d8816da6e2c78e64228d1809ad3e4a5da1f756b41ad3c773be84af8782705'
AND (
token = 'qcEC0LZUVHmwcGL4HCPxOp8pfT96E56FRaatHGMpLBc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)