UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zub5I6+mYNtxoMS9u2jrQA50/yR63Io5SFKDApK4Ex8='
WHERE
key_id = 'f78c98e53288a18f906811951e00a461b3b26c7577f7d105fec80464d552b530'
AND (
token = 'Zub5I6+mYNtxoMS9u2jrQA50/yR63Io5SFKDApK4Ex8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)