UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Th5DFVgkl3+yKzqmCXftEg51RzpjsHcPTmpy/b6nNl4='
WHERE
key_id = '731fcada885cc006e3df6805b0ae3a205a6d97068319fe39b23cb8067514b210'
AND (
token = 'Th5DFVgkl3+yKzqmCXftEg51RzpjsHcPTmpy/b6nNl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)