UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kOpPp4Ag9vv+2iD1O8+SG1R+A0r+Tk2Tr9C3jvVDng4='
WHERE
key_id = 'c8bc42787ccc507401dc57f4a0f3a2432b33591860c80ef481b3bcf9f6664df2'
AND (
token = 'kOpPp4Ag9vv+2iD1O8+SG1R+A0r+Tk2Tr9C3jvVDng4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)