UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7vdKnhIMrnrT4vcTW29nfLxl5Oft8/3P7Nm0aGTsHA4='
WHERE
key_id = 'a46a08a524e206c2506720e8f07790bb1c31613bbbcfb5f5ad9e296a274a604d'
AND (
token = '7vdKnhIMrnrT4vcTW29nfLxl5Oft8/3P7Nm0aGTsHA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)