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