UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BmDTsFL7pzm4qTA/B69gGvGHS/Jk5fWj4L0cGXU+VM8='
WHERE
key_id = '1a123738a1f2521b0460d4a03897124263cfb73b0c386cf00b2da53e5ef8747c'
AND (
token = 'BmDTsFL7pzm4qTA/B69gGvGHS/Jk5fWj4L0cGXU+VM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)