UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JoLDdkUlS7yaZsN94OmSo9s6tgKsDWbzAuf6L33aWHc='
WHERE
key_id = '45a4a56c710454735ce75985556eab1f26af704a306840b8d906c860dc004567'
AND (
token = 'JoLDdkUlS7yaZsN94OmSo9s6tgKsDWbzAuf6L33aWHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)