UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dX0yONtmGU9NLuM2WpWWGOS/4Gw6NE8Ttov+SgM7cCs='
WHERE
key_id = '07862bd6f6d1b2337c5f7f2cd0a730335d0bf2329977614f99144a23fa3fd7f3'
AND (
token = 'dX0yONtmGU9NLuM2WpWWGOS/4Gw6NE8Ttov+SgM7cCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)