UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dEFEGbSW4qeJ2NCpjQKhx9nm6tOeX1N7VxTUkZ4PXWw='
WHERE
key_id = '41370f3e9c894501e679e880a167ae672833d0eab1c3c4ea9a56857dbb31952a'
AND (
token = 'dEFEGbSW4qeJ2NCpjQKhx9nm6tOeX1N7VxTUkZ4PXWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)