UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q1xPyrgM692b2v9Tkw38KVUAaRL5uyv2ESm1737CUY8='
WHERE
key_id = 'bfa697d7b97b3cfc565983f955e85480a4ad2f2c7ff4822b61b1aa2f06b58ea7'
AND (
token = 'Q1xPyrgM692b2v9Tkw38KVUAaRL5uyv2ESm1737CUY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)