UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NfVX7gbhXM92xPtT+9SpM/4+JbxYf0QmPjgQ9Diqvyg='
WHERE
key_id = '972f171dc0e1cda025b1fd67fc89b7fd0f3bb8d6114f5cc3d58bd4bcc8df0057'
AND (
token = 'NfVX7gbhXM92xPtT+9SpM/4+JbxYf0QmPjgQ9Diqvyg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)