UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gDJdlqEiQ22KsSyYqIP5GBI0zPHRG+EBXSug2mSX6dY='
WHERE
key_id = 'd1825995ca44e963f5a032408f36d1f7369ca18e7793fcfc46d45f19b177a9b0'
AND (
token = 'gDJdlqEiQ22KsSyYqIP5GBI0zPHRG+EBXSug2mSX6dY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)