UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qhwsJEYna4o5RCwqNOKoj+C5ulV4fIsBv78dkMJEeFE='
WHERE
key_id = 'cc2178899b72a861ea158cd00b91c517f5eed1930b6194a5f9e77474f0116cd2'
AND (
token = 'qhwsJEYna4o5RCwqNOKoj+C5ulV4fIsBv78dkMJEeFE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)