UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZGj9f34JwlW0Zso2VLBWSIl2vicqtWRn0phm8iJAeeA='
WHERE
key_id = '5fb7f7b978ed0a0392d119bf44f2dec446d2280300730ee01f6dff923e26d8fd'
AND (
token = 'ZGj9f34JwlW0Zso2VLBWSIl2vicqtWRn0phm8iJAeeA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)