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