UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HLl5MRjFgUZp+k2pgo6s4BGZuoR666lKXb2SUG3KgcM='
WHERE
key_id = '287629377eafbf6ca761d37a36e0f18a6ab0882f0ceec4aa5a831839304009a9'
AND (
token = 'HLl5MRjFgUZp+k2pgo6s4BGZuoR666lKXb2SUG3KgcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)