UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RJEreAPlw0+hGsWQ8oFVGtxttEgitHXR9Re4H3yrB+A='
WHERE
key_id = 'e94a60cd00f3ce6cab297da5fed266e7b54add58569d35a653e8fa48ee2188da'
AND (
token = 'RJEreAPlw0+hGsWQ8oFVGtxttEgitHXR9Re4H3yrB+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)